:art: init_express_company
huangqimin001
3 changed files with 28 additions and 0 deletions
+ 27
- 0
pre/init_express_company.py
@@ -0,0 +1,27 @@ |
||
| 1 |
+# -*- coding: utf-8 -*- |
|
| 2 |
+ |
|
| 3 |
+import xlrd |
|
| 4 |
+from pysnippets.strsnippets import strip |
|
| 5 |
+ |
|
| 6 |
+from maintenance.models import ExpressCompanyInfo |
|
| 7 |
+ |
|
| 8 |
+ |
|
| 9 |
+def pre_express_company(fpath='./utils/kuaidi/快递100快递公司标准编码-20210922162915.xls'): |
|
| 10 |
+ workbook = xlrd.open_workbook(fpath) |
|
| 11 |
+ # sheet = workbook.sheet_by_name('SMR')
|
|
| 12 |
+ sheets = workbook.sheets() |
|
| 13 |
+ sheet = sheets[0] |
|
| 14 |
+ nrows = sheet.nrows |
|
| 15 |
+ for idx in range(2, nrows): |
|
| 16 |
+ rvals = sheet.row_values(idx) |
|
| 17 |
+ print(rvals) |
|
| 18 |
+ |
|
| 19 |
+ name = strip(rvals[0]) |
|
| 20 |
+ if not name: |
|
| 21 |
+ continue |
|
| 22 |
+ |
|
| 23 |
+ com = strip(rvals[1]) |
|
| 24 |
+ if not com: |
|
| 25 |
+ continue |
|
| 26 |
+ |
|
| 27 |
+ ExpressCompanyInfo.objects.update_or_create(name=name, com=com) |
+ 1
- 0
requirements.txt
@@ -15,6 +15,7 @@ rlog==0.3 |
||
| 15 | 15 |
rsa==3.4.2 |
| 16 | 16 |
shortuuid==1.0.1 |
| 17 | 17 |
versions==0.10.0 |
| 18 |
+xlrd==2.0.1 |
|
| 18 | 19 |
-r requirements_dj.txt |
| 19 | 20 |
-r requirements_pywe.txt |
| 20 | 21 |
-r requirements_redis.txt |